﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using FortuneHeavenCommon.DataMap;

namespace FortuneHeavan.Game.DAL
{
    public class UserSpreadDAL : UserDBBase
    {
        /// <summary>
        /// 获取推广积分最多的
        /// </summary>
        /// <param name="top"></param>
        public List<UserSpread> GetTopShortInfor(int top)
        {
            string sql = @"Select TOP " + top + @" A.ID,A.RegisterBroadCastID,A.SpreadScore,B.Accounts as UserName,B.FaceID,B.Gender,B.GameID from dbo.UserSpread A inner join dbo.AccountsInfo B
on A.RegisterBroadCastID = B.UserID ORDER BY  A.SpreadScore DESC";
            return Query<UserSpread>(sql);
        }
    }
}
